{
  "queryType": "regularQuery",
  "results": [
    {
      "query": {
        "measures": [
          "SnowplowTrackedEvents.count"
        ],
        "filters": [
          {
            "operator": "equals",
            "values": [
              "page_view"
            ],
            "member": "SnowplowTrackedEvents.event"
          },
          {
            "member": "SnowplowTrackedEvents.derivedTstamp",
            "operator": "inDateRange",
            "values": [
              "2023-01-02",
              "2023-07-12"
            ]
          }
        ],
        "limit": 100,
        "timezone": "UTC",
        "dimensions": [

        ],
        "timeDimensions": [

        ],
        "order": [

        ],
        "rowLimit": 100,
        "queryType": "regularQuery"
      },
      "data": [
        {
          "SnowplowTrackedEvents.count": "335"
        }
      ],
      "lastRefreshTime": "2023-07-13T09:24:31.279Z",
      "refreshKeyValues": [
        [
          {
            "refresh_key": "168924027"
          }
        ]
      ],
      "usedPreAggregations": {
      },
      "transformedQuery": {
        "sortedDimensions": [
          "SnowplowTrackedEvents.derivedTstamp",
          "SnowplowTrackedEvents.event"
        ],
        "sortedTimeDimensions": [

        ],
        "timeDimensions": [

        ],
        "measures": [
          "SnowplowTrackedEvents.pageViewsCount"
        ],
        "leafMeasureAdditive": true,
        "leafMeasures": [
          "SnowplowTrackedEvents.count"
        ],
        "measureToLeafMeasures": {
          "SnowplowTrackedEvents.count": [
            {
              "measure": "SnowplowTrackedEvents.count",
              "additive": true,
              "type": "count"
            }
          ]
        },
        "hasNoTimeDimensionsWithoutGranularity": true,
        "allFiltersWithinSelectedDimensions": false,
        "isAdditive": true,
        "granularityHierarchies": {
          "year": [
            "year",
            "quarter",
            "month",
            "month",
            "day",
            "hour",
            "minute",
            "second"
          ],
          "quarter": [
            "quarter",
            "month",
            "day",
            "hour",
            "minute",
            "second"
          ],
          "month": [
            "month",
            "day",
            "hour",
            "minute",
            "second"
          ],
          "week": [
            "week",
            "day",
            "hour",
            "minute",
            "second"
          ],
          "day": [
            "day",
            "hour",
            "minute",
            "second"
          ],
          "hour": [
            "hour",
            "minute",
            "second"
          ],
          "minute": [
            "minute",
            "second"
          ],
          "second": [
            "second"
          ]
        },
        "hasMultipliedMeasures": false,
        "hasCumulativeMeasures": false,
        "windowGranularity": null,
        "filterDimensionsSingleValueEqual": null,
        "ownedDimensions": [
          "SnowplowTrackedEvents.derivedTstamp",
          "SnowplowTrackedEvents.event"
        ],
        "ownedTimeDimensionsWithRollupGranularity": [

        ],
        "ownedTimeDimensionsAsIs": [

        ]
      },
      "requestId": "e10b4c42-3546-48d2-be32-22b48bd153b0-span-1",
      "annotation": {
        "measures": {
          "SnowplowTrackedEvents.count": {
            "title": "Snowplow Tracked Events Count",
            "shortTitle": "Event Count",
            "type": "number",
            "drillMembers": [

            ],
            "drillMembersGrouped": {
              "measures": [

              ],
              "dimensions": [

              ]
            }
          }
        },
        "dimensions": {
        },
        "segments": {
        },
        "timeDimensions": {
        }
      },
      "dataSource": "default",
      "dbType": "clickhouse",
      "extDbType": "cubestore",
      "external": false,
      "slowQuery": false,
      "total": null
    }
  ],
  "pivotQuery": {
    "measures": [
      "SnowplowTrackedEvents.count"
    ],
    "filters": [
      {
        "operator": "equals",
        "values": [
          "page_view"
        ],
        "member": "SnowplowTrackedEvents.event"
      },
      {
        "member": "SnowplowTrackedEvents.derivedTstamp",
        "operator": "inDateRange",
        "values": [
          "2023-01-02",
          "2023-07-12"
        ]
      }
    ],
    "limit": 100,
    "timezone": "UTC",
    "dimensions": [

    ],
    "timeDimensions": [

    ],
    "order": [

    ],
    "rowLimit": 100,
    "queryType": "regularQuery"
  },
  "slowQuery": false
}
